package com.demo.mapper;

import com.demo.pojo.entity.Teacher;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

/**
* @author lenovo
* @description 针对表【teacher】的数据库操作Mapper
* @createDate 2025-09-11 17:15:14
* @Entity com.demo.pojo.entity.Teacher
*/
@Mapper
public interface TeacherMapper extends BaseMapper<Teacher> {


    @Select("select * from teacher where teacher_id = #{id}")
    Teacher selectById2(Integer id);

    @Select("select * from teacher where te_no = #{teNo}")
    Teacher selectByNO(Long teNo);

    @Select("select * from teacher where te_name = #{teName} and te_phone = #{tePhone} limit 1")
    Teacher selectByNameAndPhone(String teName, String tePhone);
}




